package com.feicheng.base.common;

public class DaoConstant {

    public static class STOCK {
        public static final String STOCK_ID = "stock_id";
        public static final String PRODUCT_ID = "product_id";
        public static final String NUM = "num";
        public static final String WAREHOUSE_ID = "warehouse_id";
    }

    public static class STORE_USER {
        public static final String TABLE = "store_user";
        public static final String STORE_ID = "store_id";
        public static final String USER_ID = "user_id";
    }
    public static class PRODUCT {
        public static final String PRODUCT_ID = "product_id";
        public static final String TYPE = "type";
        public static final String PRODUCT_NAME = "product_name";
        public static final String PRICE = "price";
        public static final String DESCRIPTION = "description";
        public static final String STATE = "state";
    }

    public static class PURCHASE_HEADER {
        public static final String TABLE = "purchase_header";
        public static final String PURCHASE_HEADER_ID = "purchase_header_id";
        public static final String DATE = "date";
        public static final String USER_ID = "user_id";
        public static final String BATCH_NO = "batch_no";
        public static final String STATE = "state";
        public static final String STORE_ID = "store_id";

    }

    public static class PURCHASE_ITEM {
        public static final String TABLE = "purchase_item";
        public static final String PURCHASE_ITEM_ID = "purchase_item_id";
        public static final String PURCHASE_HEADER_ID = "purchase_header_id";
        public static final String TYPE = "type";
        public static final String NAME = "name";
        public static final String DESCRIPTION = "description";
        public static final String PRICE = "price";
        public static final String NUM = "num";
    }

    public static class MODEL {

        public static class INTOHEADER_WITH_ITEM {
            public static final String USER_NAME = "user_name";
            public static final String WAREHOUSE_NAME = "warehouse_name";
            public static final String STATEDATE = "stateDate";
            public static final String ENDDATE = "endDate";
            public static final String PBATCH = "pbatch";
        }

        public static class USER_AND_WAREHOUSE {
            public static final String USER_NAME ="user_name";
            public static final String STORE_ID ="store_id";

        }

        public static class INTOITEM {
            public static final String INTO_ITEM_ID = "into_item_id";
            public static final String INTO_HEADER_ID = "into_header_id";
            public static final String PRODUCT_ID = "product_id";
            public static final String INTO_PRODUCT_NUM = "into_product_num";
        }

        public static class PURCHASE_HEADER_WITH_USER {
            public static final String TABLE = "purchaseHeaderWithUser";
            public static final String TELEPHONE = "telephone";
            public static final String START_DATE = "start_date";
            public static final String END_DATE = "end_date";
            public static final String USER_NAME = "user_name";
        }

        public static class OUTBOUNDWITHSALE {
            public static final String MODEL_NAME = "outbound_with_sale";
            public static final String WAREHUOSE_NAME = "warehouse_name";
            public static final String SALE_NO = "sale_no";
            public static final String USER_NAME = "user_name";

        }

        public static class  PRODUCTWITHNUM {
            public static final String MODEL_NAME = "productWithNum";

        }

        public static class INTOWITHPURCHASE {
            public static final String MODEL_NAME = "into_with_purchase";
            public static final String WAREHOUSE_NAME = "warehouse_name";
            public static final String PURCHASE_NO = "purchase_no";
            public static final String USER_NAME = "user_name";
        }

        public static class PRODUCTWITHNUMBER {
            public static final String MODEL_NAME = "product_with_number";
            public static final String PRODUCT_ID = "product_id";
            public static final String PRODUCT_NAME = "product_name";
        }
        public static class OUTBOUNDWITHSALEWITHWAREHOUSE {
            public static final String MODEL_NAME = "outbound_with_sale_with_warehouse";
            public static final String WAREHOUSE_NAME = "warehouse_name";
            public static final String SALE_NO = "sale_no";
            public static final String USER_NAME = "user_name";
        }

        public static class USER {
            public static final String TABLE = "user";
            public static final String USER_ID = "user_id";
            public static final String USER_NAME = "user_name";
        }
    }

    public static class VALUE {
        public static final Integer DEFAULT_STATE = 1;
        public static final Integer SALE_HEADER_LOCALDATE = 8;
        public static final String SALE_BATCHNO = "S";
        public static final String Y = "Y";
        public static final String STATE = "0";
    }

    public static class WAREHOUSESTORE {
        public static final String TABLE = "warehouse_store";
        public static final String WAREHOUSE_ID = "warehouse_id";
        public static final String STORE_ID = "store_id";
    }
    public static class INTO_HEADER {
        public static final String TABLE = "into_header";
        public static final String INTO_HEADER_ID = "into_header_id";
        public static final String INTO_WAREHOUSE_DATE = "into_warehouse_date";
        public static final String BATCH_NO = "batch_no";
        public static final String PURCHASE_HEADER_ID = "purchase_house_id";
        public static final String WAREHOUSE_ID = "warehouse_id";
        public static final String USER_ID = "user_id";
    }
    public static class SALEORDER_HEADER{

        public static final String TABLE = "sale_order_header";
        public static final String CUSTOMER_NAME = "customer_name";
        public static final String CUSTOMER_TELEPHONE = "customer_telephone";
        public static final String CUSTOMER_FRAME_NO = "customer_frame_no";
        public static final String CUSTOMER_CAR_NO = "customer_car_no";
        public static final String USER_ID = "user_id";
        public static final String STORE_ID = "store_id";
        public static final String DATE = "date";
        public static final String BATCH_NO = "batch_no";
        public static final String SALESPERSON = "salesperson";
        public static final String STATE = "state";
    }
    public static class SALE_ORDER_ITEM{
        public static final String TABLE = "sale_order_item";
        public static final String SALE_ITEM_ID = "sale_item_id";
        public static final String SALE_ID = "sale_id";
        public static final String PRODUCT_TYPE = "product_type";
        public static final String PRODUCT_NAME = "product_name";
        public static final String DESCRIPTION = "description";
        public static final String NUM = "num";
        public static final String PRICE = "price";
        public static final String CAR_PART = "car_part";
    }

    public static class SALE {
        public static final String TABLE = "sale_order_header";
        public static final String SALE_ID = "sale_id";
        public static final String CUSTOMER_NAME = "customer_name";
        public static final String CUSTOMER_TELEPHONE = "customer_telephone";
        public static final String CUSTOMER_FRAME_NO = "customer_frame_no";
        public static final String CUSTOMER_CAR_NO = "customer_car_no";
        public static final String USER_ID = "user_id";
        public static final String STORE_ID = "store_id";
        public static final String DATE = "date";
        public static final String BATCH_NO = "batch_no";
        public static final String SALESPERSON= "salesperson";
        public static final String STATE = "state";
    }

    public static class SALE_ITEM {
        public static final String TABLE = "sale_order_item";
        public static final String SALE_ID = "sale_id";
        public static final String PRODUCT_ID = "product_id";
        public static final String PRODUCT_TYPE = "product_type";
        public static final String PRODUCT_NAME = "product_name";
        public static final String DESCRIPTION = "description";
        public static final String NUM = "num";
        public static final String PRICE = "price";
        public static final String CAR_PART = "car_part";
    }
    public static class  OUTBOUNDHEADER {
        public static final String TABLE_NAME = "outbound_header";
        public static final String OUTBOUND_HEADER_ID = "outbound_header_id";
        public static final String DATE = "date";
        public static final String BATCH_NO = "batch_no";
        public static final String SALE_ID = "sale_id";

    }
    public static class OUTBOUNDITEM{
        public static final String TABLE_NAME = "outbound_item";
        public static final String OUTBOUND_ITEM_ID = " outbound_item_id";
        public static final String OUTBOUND_HEADER_ID = "outbound_header_id";
        public static final String PRODUCT_ID = "product_id";
        public static final String OUTBOUND_PRODUCT_NUM = "outbound_product_num";
    }
    public static class STORE {
        public static final String STORE_ID = "store_id";
        public static final String STORE_NAME = "store_name";
        public static final String ADDRESS = "address";
        public static final String DESCRIPTION = "description";
        public static final String TELEPHONE = "telephone";
        public static final String STATE = "state";
    }

    public static class INTO_ITEM {
        public static final String TABLE = "into_item";
        public static final String INTO_ITEN_ID = "into_item_id";
        public static final String INTO_HEADER_ID = "into_header_id";
        public static final String PRODUCT_ID = "product_id";
        public static final String INTO_PRODUCT_NUM = "into_product_num";
    }

    public static class WAREHOUSE{
        public static final String TABLE = "warehouse";
        public static final String WAREHOUSE_ID = "warehouse_id";
        public static final String WAREHOUSE_NAME = "warehouse_name";
        public static final String USER_ID = "user_id";
        public static final String ADDRESS = "address";
        public static final String D_FLG = "d_flg";
        public static final String STATE = "state";
        public static final String WAREHOUSEID ="warehouse_id";
        public static final String STOREID = "store_id";

    }

    public static class SALE_ORDER_HEADER {
        public static final String TABLE = "sale_order_header";
        public static final String SALE_ID = "sale_id";
        public static final String CUSTOMER_NAME = "customer_name";
        public static final String CUSTOMER_TELEPHONE = "customer_telephone";
        public static final String CUSTOMER_FRAME_NO = "customer_frame_no";
        public static final String CUSTOMER_CAR_NO = "customer_car_no";
        public static final String USER_ID = "user_id";
        public static final String STORE_ID = "store_id";
        public static final String DATE = "date";
        public static final String BATCH_NO = "batch_no";
        public static final String SALESPERSON = "salesperson";
        public static final String STATE = "state";
    }
    public static class USER {
        public static final String TABLE = "user";
        public static final String USERINFO = "user_info";
        public static final String USERID = "userId";
        public static final String USERNAME = "user_name";
        public static final String ACCOUNT = "account";
        public static final String PASSWORD = "password";
        public static final String RESULT_DATA = "resultData";
    }

    public static class STOCKANDPRODUCT{
        public static final String  TYPE = "type";
        public static final String  PRODUCT_NAME = "product_name";
        public static final String  WAREHOUSE_NAME = "warehouse_Name";
        public static final String  USER_NAME = "user_name";
        public static final String  ADDRESS = "address";
    }
}